﻿using System;
using System.Collections.Generic;
using System.Text;

namespace OneMake.Model
{
    //赤兔绩效客件数对比
    [PetaPoco.TableName("product_archive")]
    [PetaPoco.PrimaryKey("oid")]
    public class product_archive
    {
        [MapToField(FieldName = "统计日期")]
        public DateTime stat_datetime { get; set; }         //  date	

        [MapToExcel(ColumnName = "SKU码")]
        public string sku { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "品牌")]
        public string trademark { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "商品货号")]
        public string product_sn { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "是否特供款")]
        public string is_special { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "品名")]
        public string type_name { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "品类")]
        public string catelog { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "大类")]
        public string big_type { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "性别")]
        public string sex { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "年份")]
        public int year { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "季节")]
        public string season { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "颜色名称")]
        public string color_name { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "颜色代码")]
        public string color_code { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "尺码")]
        public string size_name { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "尺码代码")]
        public string size_code { get; set; }                      //  varchar(30)	

        [MapToExcel(ColumnName = "吊牌价")]
        public double label_price { get; set; }                      //  varchar(30)	


		/////////////////////////////////////////
        [MapToField(FieldName = "门店编号")]
        public int shopid { get; set; }
        [MapToField(FieldName = "文件编号")]
        public int fileid { get; set; }
        [MapToField(FieldName = "编号")]
        public int oid { get; private set; }    
    }
}
